Step 1: Create Homework / Video Column
- Select Home and then Data transform
- Select the Video column and right click, choose to duplicate column
- Go to duplicated column and select drop down arrow to change data type to text.
- Select drop down arrow again to choose replace values, change 0 to homework and 1 to video.
-Rename the column to Homework / Video
How to create calculated column ?